forum

home / developersection / forums / display data column wise

Ask Question

Display data Column wise

Manmohan Jha 2248 29-Sep-2013
Hello developers...
I have some problem

My Sql table look like this..
Session               Student Id     Subject       MarksType      Marks
2013-2014         S00001         Math          FA1                 50
2013-2014         S00001         Hindi          FA1                 60
2013-2014         S00001         English       FA1                  62
2013-2014         S00001         Math          FA2                 55
2013-2014         S00001         Hindi          FA2                 62
2013-2014         S00001         English       FA2                  70
But i want print like this
Session               Student Id     Subject       FA1             FA2
2013-2014         S00001         Math          50                55
2013-2014         S00001         Hindi          60                62
2013-2014         S00001         English       62                 70
Help me...


Thx & regards
Manmohan Jha
c# c# 
Updated on 30-Sep-2013
Manmohan Jha

Other

Message
Can you answer this question?
Answer

1 Answers

Manmohan Jha

Manmohan Jha

30-Sep-2013
Query:-
In Access 2007
TRANSFORM Avg(Marks) as Mrk  SELECT Subject FROM StudentsMarks WHERE Session='2013-2014' AND Student Id='S00001' GROUP BY Session_,Student Id, Subject PIVOT MarksType In (FA1, FA2)
How to use same query in Sql?
MindStick Training
MindStick Training

Liked By

We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy